Hệ thống quản lý trường học bằng PHP / MySQLi
1 <?php
2 include("connect.php");
3 ?>
4 <?php
5 require_once('session1.php');
6 ?>
7 <!--*****************Analysis data*****************************-->
8 <?php
9 SESSION_START();
10 ?>
11
12 <!DOCTYPE html>
13 <html>
14 <head>
15 <meta charset="utf-8">
16 <meta name="viewport" content="width=device-width, initial-scale=1.0">
17 <title>school management system</title>
18 <link rel="shortcut icon" href="assets/img/title.gif" type="image/x-icon">
19 <link rel="stylesheet" href="assets/css/bootstrap.min.css">
20 <link href="assets/css/loader.css" rel="stylesheet" />
21 <script src="assets/js/canvasjs.min.js"></script>
22 <!--*****jquery -3.2.1.js file supports the use of dropdown***-->
23 <script src="assets/js/jquery-3.2.1.js"></script>
24
25
26 </head>
27 <!--<style type="text/css">
28 body{
29 margin-right: 10px;
30 margin-left: 10px;
31 }
32 </style>
33
34 -->
35
36 <body >
37 <!--end of heading section-->
38 <ul class="nav navbar-right top-nav">
39 <div class="dropdown">
40 <button class="btn btn-primary dropdown-toggle" type="button" data-toggle="dropdown" >
41 <?php
42 //Check to see if the user is logged in.if not redirect user to the loging page.
43
44 if(isset($_SESSION['fname']))
45 {
46 echo "Current user: ".$_SESSION['fname']. " ".$_SESSION['lname']. " ";
47 }else{
48 echo "<script type='text/javascript'>
49 alert( 'You must Log in to use the system');
50 </script>";
51 echo "<script>
52 window.location = 'index.php'
53 </script>";
54 }
55 ?>
56 <span class="caret"></span></button>
57 <ul class="dropdown-menu">
58 <li><a href="manage_account.php"><i class="fa fa-users fa-lg"></i> View User</a></li>
59 <li><a href="register_form.php"><i class="fa fa-users fa-lg"></i> Add New User</a></li>
60 <li class="divider"></li>
61 <li><a href="session_logout.php"><i class="fa fa-fw fa-power-off"></i> Log Out</a></li>
62 </ul>
63 </div>
64 </ul>
65 <!--************************************************-->
66 <div style="
67 font-family:Nyala, Arial;
68 text-align: left;
69 background-color: #526F35;
70 padding: 20px;
71 color:white;
72 width: 100%;
73 height: 150px;">
74 <!--This codes to load the image loader-->
75 <div id="loading">
76 <img id="loading-image" src="assets/img/loader.gif" alt="Loading..." />
77 </div>
78 <!--this is the heading section-->
79 <h2>
80 <?php
81 $sql="SELECT * FROM companyinfo";
82 $result=mysqli_query($db,$sql) or die("error getting data");
83 $num_rows=mysqli_num_rows($result);
84 while($row=mysqli_fetch_array($result))
85 {
86 echo '<image style="height:82px; width:82px;" src="data:image;base64,'. $row['clogo'].' "> ';
87 $cname = $row['cname'];
88 $cemail = $row['cemail'];
89 $ccontact = $row['ccontact'];
90 $clocation = $row['clocation'];
91 }?>
92 <?php
93 echo $cname;
94 ?>
95
96 <div style="float:right; font-size:20px;text-align:right;">
97
98 <img src="assets/img/mail2.png">Email: <?php echo $cemail; ?><br>
99 <img src="assets/img/call1.png">Contact:<?php echo $ccontact; ?><br>
100 <img src="assets/img/location.png">Location: <?php echo $clocation; ?>
101
102 </div>
103 </h2>
104 </div>
105 <div>
106 <ul class="nav nav-tabs">
107 <li class="active"><a href="homepage.php" >Administration <img src="assets/img/details.png"></a></li>
108 <li ><a href="students.php" >Students <img src="assets/img/student48.png"></a></li>
109 <li><a href="staff.php">Staff Member <img src="assets/img/staff48.png"></a></li>
110 <li><a href="course.php" >Courses <img src="assets/img/course.png"></a></li>
111 <li><a href="departments.php" >Departments <img src="assets/img/department.png"></a></li>
112 <li><a href="markstep1.php" >Exams <img src="assets/img/update.png"></a></li>
113 <li><a href="hostel.php" >Hostel <img src="assets/img/details.png"></a></li>
114 <li><a href="sms.php">SMS <img src="assets/img/details.png"></a></li>
115 <!--<li><a href="tab-8" role="tab" data-toggle="tab">Hostel <img src="assets/img/details.png"></a></li>
116 <li><a href="tab-7" role="tab" data-toggle="tab">Parents <img src="assets/img/details.png"></a></li>-->
117
118 </ul>
119 <div class="tab-content">
120 <div class="tab-pane active" role="tabpanel" id="tab-1">
121
122 <p>
123 <div class="table-responsive" >
124 <!--****************************************************************************-->
125 <div class="container" style="width:100%">
126
127 <ul class="nav nav-tabs">
128 <li ><a href="register_form.php">New user <img src="assets/img/new.png"> </a></li>
129 <li class="active"><a href="manage_account.php">View users<img src="assets/img/view2.png"></a></li>
130
131 </ul>
132 <br>
133
134 </div>
135 <!--****************************************************************************-->
136
137 <nav>
138 <center><h2>Manage Account<h2></center>
139 <div class="col-sm-12">
140 <div class="span7" id="">
141 <div class="row-fluid">
142 <?php
143 $count_client=mysqli_query("select * from admin");
144 $count = mysqli_num_rows($count_client);
145 ?>
146 <!-- block -->
147 <div id="block_bg" class="block">
148 <div class="navbar navbar-inner block-header">
149 <br>
150 <div class="muted pull-right"> Admin List </div><div class="muted pull-right"><span class="label label-warning"><?php echo $count;?></span></div>
151
152 <div class="block-content collapse in">
153 <div class="span12">
154
155 <!-----------------------form --------------------->
156
157 <table cellpadding="0" cellspacing="0" border="0" class="table" id="example">
158
159 <thead>
160 <tr>
161 <th></th>
162 <th>Name</th>
163 <th>Username</th>
164 <th>Edit</th>
165 <script src="js/jquery.dataTables.min.js"></script>
166 <script src="js/DT_bootstrap.js"></script>
167 <th></th>
168 </tr>
169 </thead>
170 <tbody>
171 <?php
172 $user_query = mysqli_query("select * from admin")or die(mysqli_error());
173 while($row = mysqli_fetch_array($user_query)){
174 $id = $row['admin_id'];
175 ?>
176
177 <tr>
178 <td width="30">
179 </td>
180 <td><?php echo $row['fname']; ?> <?php echo $row['lname']; ?></td>
181
182 <td><?php echo $row['username']; ?></td>
183
184 <td class="col-md-1">
185 <a href="admin_edit.php <?php echo '?id='.$id; ?>" class="btn btn-success"><i class="glyphicon glyphicon-pencil"></i></a>
186
187 </tr>
188 <?php } ?>
189 </tbody>
190 </table>
191 </form>
192
193 </div>
194 </div>
195 </div>
196
197 </div>
198 <!-- /.container-fluid -->
199
200 </div>
201 <!-- /#page-wrapper -->
202
203 </div>
204 </div>
205 </div>
206 </div>
207 </div>
208 </nav>
209 <!-- /#wrapper -->
210
211
212 <!--*********************************************************************************-->
213 <div class="col-md-12" style="background-color:#526F35; position:fixed;bottom:0px;">
214 <p class="text-center text-danger" style="color:white;" >@J. Muthama Tel: +254729734768</p>
215 </div>
216
217 <script src="assets/js/jquery.min.js"></script>
218 <script src="assets/js/affix.js"></script>
219 <script src="assets/js/alert.js"></script>
220 <script src="assets/js/alert1.js"></script>
221 <script src="assets/js/bootstrap.js"></script>
222 <script src="assets/js/bootstrap.min.js"></script>
223 <script src="assets/js/bootstrap-datepicker.js"></script>
224 <script src="assets/js/bootstrap-wysihtml5.js"></script>
225 <script src="assets/js/button.js"></script>
226 <script src="assets/js/carousel.js"></script>
227 <script src="assets/js/chosen.jquery.min.js"></script>
228 <script src="assets/js/ckeditor.js"></script>
229 <script src="assets/js/collapse.js"></script>
230 <script src="assets/js/color.js"></script>
231 <script src="assets/js/dropdown.js"></script>
232 <script src="assets/js/DT_bootstrap.js"></script>
233 <script src="assets/js/dynamic.js"></script>
234 <script src="assets/js/ie-emulation-modes-warning.js"></script>
235 <script src="assets/js/jquery.dataTables.js"></script>
236 <script src="assets/js/jquery.dataTables.min.js"></script>
237 <script src="assets/js/jquery.dialog.js"></script>
238 <script src="assets/js/jquery.hoverdir.js"></script>
239 <script src="assets/js/jquery.jgrowl.js"></script>
240 <script src="assets/js/jquery.knob.js"></script>
241 <script src="assets/js/jquery.uniform.min.js"></script>
242 <script src="assets/js/jquery-1.8.3.min.js"></script>
243 <script src="assets/js/jquery-1.9.1.js"></script>
244 <script src="assets/js/jquery-1.9.1.min.js"></script>
245 <script src="assets/js/jquery-1.10.2.js"></script>
246 <script src="assets/js/jquery-1.11.0.js"></script>
247 <script src="assets/js/jquery-ui-1.9.2.custom.min.js"></script>
248 <script src="assets/js/jquery-ui-1.10.3.js"></script>
249 <script src="assets/js/modal.js"></script>
250 <script src="assets/js/modernizr-2.6.2-respond-1.1.0.min.js"></script>
251 <script src="assets/js/myjquery.js"></script>
252 <script src="assets/js/myjquery1.js"></script>
253 <script src="assets/js/npm.js"></script>
254 <script src="assets/js/popover.js"></script>
255 <script src="assets/js/profile.js"></script>
256 <script src="assets/js/raphael-min.js"></script>
257 <script src="assets/js/sb-admin-2.js"></script>
258 <script src="assets/js/scripts.js"></script>
259 <script src="assets/js/scrollspy.js"></script>
260 <script src="assets/js/tab.js"></script>
261 <script src="assets/js/tooltip.js"></script>
262 <script src="assets/js/transition.js"></script>
263 <script src="assets/js/wysihtml5-0.3.0.js"></script>
264 <script src="assets/js/slideshow.js"></script>
265
266 <script language="javascript" type="text/javascript">
267 $(window).load(function()
268 {
269 $('#loading').hide();
270 });
271 </script>
272
273 <script>
274 $(document).ready(function(){
275 $('.dropdown-submenu a.test').on("click", function(e){
276 $(this).next('ul').toggle();
277 e.stopPropagation();
278 e.preventDefault();
279 });
280 });
281 </script>
282 </body>
283
284 </html>